SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[usp_GetEmployeeByAccount]
    (
      @JOL_Employee_Account VARCHAR(50)
    )
AS 
    SELECT  JOL_Employee_Account,
            JOL_Employee_Password,
            JOL_Employee_Name,
            JOL_Employee_Sex,
            JOL_Employee_School,
            JOL_Employee_Profession,
            JOL_Employee_Longevity,
            JOL_Employee_StudyMethod,
            JOL_Employee_TrainMethod,
            JOL_Employee_StudyYearIn,
            JOL_Employee_StudyYearOut,
            JOL_Employee_IDCardNo,
            JOL_Employee_Nation,
            JOL_Employee_Politics,
            JOL_Employee_Place,
            JOL_Employee_TrainUnit,
            JOL_Employee_Mobile,
            JOL_Employee_Email,
            JOL_Employee_CredentialsFileLink,
            JOL_Employee_AddTime,
            JOL_Employee_AddUser,
            JOL_Employee_UpdateTime,
            JOL_Employee_UpdateUser,
            JOL_Employee_VerifyStatus,
            JOL_Employee_VerifyTime,
            JOL_Employee_VerifyUser,
            JOL_Employee_VerifyIsSendEmail,
            JOL_Employee_Province
    FROM    dbo.JOL_Employee
    WHERE   JOL_Employee_Account = @JOL_Employee_Account

GO
